package cn.com.ali.maxcompute;

public interface Config {
    String JDBC_URL = "jdbc:odps:http://service.cn-chengdu.maxcompute.aliyun.com/api?project=zdjx&useProjectTimeZone=true";
    String DRIVER_NAME = "com.aliyun.odps.jdbc.OdpsDriver";
    String ACCESSID = "LTAI5tK4uLqXeLd5RAKUWkgJ";
    String ACCESSKEY = "Z8SN6Rlmd2oqHmZVkPXh30jmr1CsUT";
    String ENDPOINT= "http://service.odps.aliyun.com/api";
    String PROJECT = "zdjx";

    interface SQL {
        String CREATE = "create table t_shujufuwu (\n" +
                "    id STRING ,\n" +
                "    username STRING ,\n" +
                "    age INT  ,\n" +
                "    remark STRING ,\n" +
                "    create_time DATETIME ,\n" +
                "    last_modify DATETIME \n" +
                ")";
        String QUERY = "select * from zdjx.t_shujufuwu";
        String INSERT = "insert into t_shujufuwu (id,username,age,remark,create_time,last_modify) VALUES (1,'zs',26,'控制台输入',to_date('20230526', 'yyyymmdd'),to_date('20230526', 'yyyymmdd'))";
    }
}
